﻿CREATE TABLE [dbo].[CLM_837I_2000A_BillingPayToProvider]
(
[PayToProvider_HL01_HierarchicalIDNumber] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_HL03_HierarchicalLevelCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_HL04_HierarchicalChildCode] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_PRV01_ProviderCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_PRV02_ReferenceIdentificationQualifier] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_PRV03_ProviderTaxonomyCode] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_CUR01_ProviderEntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayToProvider_CUR02_ProviderCurrencyCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_NM101_BillingProviderEntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_NM102_BillingProviderEntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_NM103_BillingProviderLastOrOrganizationalName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_NM108_BillingProviderIdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_NM109_BillingProviderIdentifier] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_N301_BillingProviderAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_N302_BillingProviderAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_N401_BillingProviderCityName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_N402_BillingProviderStateOrProvinceCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_N403_BillingProviderZIPCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_N404_BillingProviderCountryCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER01_1BillingProviderContactFunctionCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER02_1BillingProviderContactName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER03_1BillingProviderCommunicationNumberQualifier1] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER04_1BillingProviderCommunicationNumber1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER05_1BillingProviderCommunicationNumberQualifier2] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER06_1BillingProviderCommunicationNumber2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER07_1BillingProviderCommunicationNumberQualifier3] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER08_1BillingProviderCommunicationNumber3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER01_2BillingProviderContactFunctionCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER02_2BillingProviderContactName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER03_2BillingProviderCommunicationNumberQualifier1] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER04_2BillingProviderCommunicationNumber1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER05_2BillingProviderCommunicationNumberQualifier2] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER06_2BillingProviderCommunicationNumber2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER07_2BillingProviderCommunicationNumberQualifier3] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Billing_PER08_2BillingProviderCommunicationNumber3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_NM101_PayToProviderEntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_NM102_PayToProviderEntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_NM103_PayToProviderLastOrOrganizationalName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_NM108_PayToProviderIdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_NM109_PayToProviderIdentifier] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_N301_PayToProviderAddressLine1] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_N301_PayToProviderAddressLine2] [nvarchar] (55) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_N401_PayToProviderCityName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_N402_PayToProviderStateOrProvinceCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_N403_PayToProviderZIPCode] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PayTo_N404_PayToProviderCountryCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[BTSMessageID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSInterchangeID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


